﻿-- on (localdb)\v11.0
use SportsStore;

CREATE TABLE [dbo].[Products]
(
	[ProductId] INT NOT NULL PRIMARY KEY, 
    [Name] NVARCHAR(100) NOT NULL, 
    [Description] NVARCHAR(500) NOT NULL, 
    [Category] NVARCHAR(50) NOT NULL, 
    [Price] DECIMAL(16, 2) NOT NULL
);

INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(1, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(2, 'Lifejacket', 'Protective and fashionable', 'Watersports', 48.95);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(3, 'Soccer ball', 'FIFA-approved size and weight', 'Soccer', 19.50);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(4, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(5, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(6, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(7, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(8, 'Kayak', 'A boat for one person', 'Watersports', 275.01);
INSERT INTO Products(ProductId, Name, Description, Category, Price)
VALUES(9, 'Kayak', 'A boat for one person', 'Watersports', 275.01);

COMMIT;

